CREATE TABLE [dbo].[Ref_Provider]
(
[PROVIDER_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Ref_Provider_PROVIDER_ID] DEFAULT (''),
[LAST_FIRST] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Ref_Provider_LAST_FIRST] DEFAULT (''),
[COMPANY] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Ref_Provider_COMPANY] DEFAULT (''),
[ZIP] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Ref_Provider_ZIP] DEFAULT (''),
[INDEX_1] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Ref_Provider_INDEX_1] DEFAULT (''),
[INDEX_2] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Ref_Provider_INDEX_2] DEFAULT (''),
[INDEX_3] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Ref_Provider_INDEX_3] DEFAULT (''),
[INDEX_4] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Ref_Provider_INDEX_4] DEFAULT (''),
[INDEX_5] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Ref_Provider_INDEX_5] DEFAULT (''),
[INDEX_6] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Ref_Provider_INDEX_6] DEFAULT (''),
[LAST_REFERRED] [datetime] NULL,
[REFERRAL_COUNT] [int] NOT NULL CONSTRAINT [DF_Ref_Provider_REFERRAL_COUNT] DEFAULT ((0)),
[STATUS] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Ref_Provider_STATUS] DEFAULT (''),
[PHONE] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Ref_Provider_PHONE] DEFAULT (''),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX [iRef_ProviderINDEX_1] ON [dbo].[Ref_Provider] ([INDEX_1]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iRef_ProviderINDEX_2] ON [dbo].[Ref_Provider] ([INDEX_2]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iRef_ProviderINDEX_3] ON [dbo].[Ref_Provider] ([INDEX_3]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iRef_ProviderINDEX_4] ON [dbo].[Ref_Provider] ([INDEX_4]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iRef_ProviderINDEX_5] ON [dbo].[Ref_Provider] ([INDEX_5]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iRef_ProviderINDEX_6] ON [dbo].[Ref_Provider] ([INDEX_6]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iRef_ProviderLAST_FIRST] ON [dbo].[Ref_Provider] ([LAST_FIRST]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iRef_ProviderLAST_REFERRED] ON [dbo].[Ref_Provider] ([LAST_REFERRED]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iRef_ProviderPROVIDER_ID] ON [dbo].[Ref_Provider] ([PROVIDER_ID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iRef_ProviderSTATUS] ON [dbo].[Ref_Provider] ([STATUS]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iRef_ProviderZIP] ON [dbo].[Ref_Provider] ([ZIP]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Ref_Provider] TO [IMIS]
GRANT SELECT ON  [dbo].[Ref_Provider] TO [IMIS]
GRANT INSERT ON  [dbo].[Ref_Provider] TO [IMIS]
GRANT DELETE ON  [dbo].[Ref_Provider] TO [IMIS]
GRANT UPDATE ON  [dbo].[Ref_Provider] TO [IMIS]
GO